die Seilerwerks

I spent the better part of 3 days banging my head against my desk trying to sort out HTTP authentication for Chef’s remote_file resource. The method itself is straight-forward: you have to Base64 encode the username and password and specify that in a hash for the headers parameter for remote_file.... [Read More]

I recently had a replica that was restarted but was having trouble getting caught up enough to enable streaming replication. The WAL archive restore & recovery was taking just a little too long. The pgBackRest team offered these very helpful tips and I wanted to share them with all of... [Read More]

We recently enabled unattended-upgrades on our Ubuntu 18.04 LTS (Bionic) servers, including our PostgreSQL hosts. By default, unattended-upgrades will ignore PGDG packages (where all of our PostgreSQL packages come from), so I had assumed we wouldn’t have any interruptions due to apt installing updates and triggering a database restart. One... [Read More]

Many RDBMSes use sequence caching to pre-generate sequence values in advance and store them in memory, allowing them to return new values quickly. If you are doing a lot of inserts that each call the sequence to get the next value, sequence caching is a good thing. Having to wait... [Read More]

Encountering the NULL [Read More]